Tabela ExternalDoctor

Definicja tabeli ExternalDoctor

Name

ExternalDoctor

Code

ExternalDoctor

Comment

PL: Definicja lekarza zewnetrznego
EN: External doctor definition


Lista kolumn tabeli ExternalDoctor

Name

Code

ExternalDoctorID

ExternalDoctorID

ExternalDoctorTypeID

ExternalDoctorTypeID

SpecialityID

SpecialityID

StuffGradeID

StuffGradeID

DegreeID

DegreeID

PersonnelTypeMHID

PersonnelTypeMHID

AddressID

AddressID

Add_AddressID

Add_AddressID

Code

Code

FirstName

FirstName

MiddleName

MiddleName

LastName

LastName

NationalIDNo

NationalIDNo

OrderingDoctorNo

OrderingDoctorNo

LicenceNo

LicenceNo

Active

Active

Comments

Comments

DefaultOrgUnitID

DefaultOrgUnitID

DocChamberRegNo

DocChamberRegNo

NurseChamberRegNo

NurseChamberRegNo

MaidenName

MaidenName


Kolumna ExternalDoctorID tabeli ExternalDoctor

Definicja kolumny ExternalDoctorID tabeli ExternalDoctor

Name

ExternalDoctorID

Code

ExternalDoctorID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExternalDoctorTypeID tabeli ExternalDoctor

Definicja kolumny ExternalDoctorTypeID tabeli ExternalDoctor

Name

ExternalDoctorTypeID

Code

ExternalDoctorTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SpecialityID tabeli ExternalDoctor

Definicja kolumny SpecialityID tabeli ExternalDoctor

Name

SpecialityID

Code

SpecialityID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StuffGradeID tabeli ExternalDoctor

Definicja kolumny StuffGradeID tabeli ExternalDoctor

Name

StuffGradeID

Code

StuffGradeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DegreeID tabeli ExternalDoctor

Definicja kolumny DegreeID tabeli ExternalDoctor

Name

DegreeID

Code

DegreeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonnelTypeMHID tabeli ExternalDoctor

Definicja kolumny PersonnelTypeMHID tabeli ExternalDoctor

Name

PersonnelTypeMHID

Code

PersonnelTypeMHID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AddressID tabeli ExternalDoctor

Definicja kolumny AddressID tabeli ExternalDoctor

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Klucz glówny tabeli
EN: Primary key of the table
DE: Der Schlüssel der Tabelle


Kolumna Add_AddressID tabeli ExternalDoctor

Definicja kolumny Add_AddressID tabeli ExternalDoctor

Name

Add_AddressID

Code

Add_AddressID

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Klucz glówny tabeli
EN: Primary key of the table
DE: Der Schlüssel der Tabelle


Kolumna Code tabeli ExternalDoctor

Definicja kolumny Code tabeli ExternalDoctor

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna FirstName tabeli ExternalDoctor

Definicja kolumny FirstName tabeli ExternalDoctor

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

PL: Imie
EN: First Name
DE: der Name


Kolumna MiddleName tabeli ExternalDoctor

Definicja kolumny MiddleName tabeli ExternalDoctor

Name

MiddleName

Code

MiddleName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna LastName tabeli ExternalDoctor

Definicja kolumny LastName tabeli ExternalDoctor

Name

LastName

Code

LastName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

PL: Nazwisko
EN: Last name
DE: der Nachname


Kolumna NationalIDNo tabeli ExternalDoctor

Definicja kolumny NationalIDNo tabeli ExternalDoctor

Name

NationalIDNo

Code

NationalIDNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna OrderingDoctorNo tabeli ExternalDoctor

Definicja kolumny OrderingDoctorNo tabeli ExternalDoctor

Name

OrderingDoctorNo

Code

OrderingDoctorNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna LicenceNo tabeli ExternalDoctor

Definicja kolumny LicenceNo tabeli ExternalDoctor

Name

LicenceNo

Code

LicenceNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna Active tabeli ExternalDoctor

Definicja kolumny Active tabeli ExternalDoctor

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Comments tabeli ExternalDoctor

Definicja kolumny Comments tabeli ExternalDoctor

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna DefaultOrgUnitID tabeli ExternalDoctor

Definicja kolumny DefaultOrgUnitID tabeli ExternalDoctor

Name

DefaultOrgUnitID

Code

DefaultOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DocChamberRegNo tabeli ExternalDoctor

Definicja kolumny DocChamberRegNo tabeli ExternalDoctor

Name

DocChamberRegNo

Code

DocChamberRegNo

Data Type

VARCHAR2(7)

Mandatory

No

Comment

Nr wpisu do rejestru okregowej izby lekarskiej. Pole wynika z rozporzadzenia MZ z dnia 21 grudnia 2010 r.


Kolumna NurseChamberRegNo tabeli ExternalDoctor

Definicja kolumny NurseChamberRegNo tabeli ExternalDoctor

Name

NurseChamberRegNo

Code

NurseChamberRegNo

Data Type

VARCHAR2(7)

Mandatory

No

Comment

Nr wpisu do rejestru okregowej izby pielegniarek i poloznych. Pole wynika z rozporzadzenia MZ z dnia 21 grudnia 2010 r.


Kolumna MaidenName tabeli ExternalDoctor

Definicja kolumny MaidenName tabeli ExternalDoctor

Name

MaidenName

Code

MaidenName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Nazwisko rodowe lekarza


Lista kluczy tabeli ExternalDoctor

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ExternalDoctor

Definicja klucza Identifier_1 tabeli ExternalDoctor

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment